﻿-- 此脚本作为平台预制数据参考使用。
-- 严禁将此脚本直接或修改后在数据库中执行,如由上述行为引发问题,概不支持。

-- ----------------------------
-- Records of WB_AREAS
-- ----------------------------
INSERT INTO [WB_AREAS] ([ID], [AREA_CODE], [AREA_NAME], [ISENABLE], [SORT], [TENANT_ID], [AREA_NAME2], [AREA_NAME3], [AREA_NAME4], [AREA_NAME5], [AREA_NAME6]) VALUES ('646966f7aa5d4b338b9897afc1629df6', '011111', '开发示例', 'Y', '9', 'tenant', 'example', '開發示例', NULL, NULL, NULL);
GO
GO
-- ----------------------------
-- Records of WB_APP_GROUPS
-- ----------------------------
-- INSERT INTO [WB_APP_GROUPS] ([ID], [NAME], [APP_GROUPINDEX], [AREA_ID], [TENANT_ID], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('c980b34f41d545f3992982442e74f7ed', 'UUI', '1', '646966f7aa5d4b338b9897afc1629df6', 'tenant', 'UUI', 'UUI', NULL, NULL, NULL);
-- GO
GO
INSERT INTO [WB_APP_GROUPS] ([ID], [NAME], [APP_GROUPINDEX], [AREA_ID], [TENANT_ID], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('6c173e474f3742a1b70960f4e1cca4df', 'React', '2', '646966f7aa5d4b338b9897afc1629df6', 'tenant', 'React', 'React', NULL, NULL, NULL);
GO
GO
-- ----------------------------
-- Records of WB_APP_APPS
-- ----------------------------
-- INSERT INTO [WB_APP_APPS] ([ID], [APP_NAME], [APP_INDEX], [GROUP_ID], [DOMAIN_ID], [URL], [APP_CHINESE], [APP_DESC], [APP_ICON], [APP_GROUPCODE], [APP_CODE], [DYNA_URL], [TENANT_ID], [URLTYPE], [VERSION], [SYSTEM], [LABEL], [SHOWWAY], [CREATOR], [REVISER], [CREATE_DATE], [MODIFY_DATE], [APP_NAME2], [APP_NAME3], [APP_NAME4], [APP_NAME5], [APP_NAME6]) VALUES ('27228e888fc34440835fec75f8fe57b7', '督办任务', null, 'c980b34f41d545f3992982442e74f7ed', '646966f7aa5d4b338b9897afc1629df6', '/example/pages/ygdemo_yw_info/ygdemo_yw_info.js', null, null, 'grey iconfont icon-appicon', null, 'ygdemo_yw_info', null, 'tenant', 'plugin', '1', 'wbalone', null, 'apparea', 'U001', null, cast('2017-05-04 15:12:23'  as datetime ), null, 'Supervising Task', '督辦任務', null, null, null);
-- GO
GO
INSERT INTO [WB_APP_APPS] ([ID], [APP_NAME], [APP_INDEX], [GROUP_ID], [DOMAIN_ID], [URL], [APP_CHINESE], [APP_DESC], [APP_ICON], [APP_GROUPCODE], [APP_CODE], [DYNA_URL], [TENANT_ID], [URLTYPE], [VERSION], [SYSTEM], [LABEL], [SHOWWAY], [CREATOR], [REVISER], [CREATE_DATE], [MODIFY_DATE], [APP_NAME2], [APP_NAME3], [APP_NAME4], [APP_NAME5], [APP_NAME6]) VALUES ('00e601475c6c471aa2cd2250bbcc7ff1', '一主一子', '', '6c173e474f3742a1b70960f4e1cca4df', '646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/masterdetail-one#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'masterdetail-one', NULL, 'tenant', 'url', '1', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:45:01.997', NULL, 'masterdetail-one', '一主一子', NULL, NULL, NULL);
GO
GO
INSERT INTO [WB_APP_APPS] ([ID], [APP_NAME], [APP_INDEX], [GROUP_ID], [DOMAIN_ID], [URL], [APP_CHINESE], [APP_DESC], [APP_ICON], [APP_GROUPCODE], [APP_CODE], [DYNA_URL], [TENANT_ID], [URLTYPE], [VERSION], [SYSTEM], [LABEL], [SHOWWAY], [CREATOR], [REVISER], [CREATE_DATE], [MODIFY_DATE], [APP_NAME2], [APP_NAME3], [APP_NAME4], [APP_NAME5], [APP_NAME6]) VALUES ('1e1573e4a3574e6bb5e8be60f164a6ee', '弹框编辑', '', '6c173e474f3742a1b70960f4e1cca4df', '646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/singletable-popup-edit#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'singletable-popupedit', NULL, 'tenant', 'url', '2', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:48:19.413', NULL, 'singletable-popupedit', '彈框編輯', NULL, NULL, NULL);
GO
GO
INSERT INTO [WB_APP_APPS] ([ID], [APP_NAME], [APP_INDEX], [GROUP_ID], [DOMAIN_ID], [URL], [APP_CHINESE], [APP_DESC], [APP_ICON], [APP_GROUPCODE], [APP_CODE], [DYNA_URL], [TENANT_ID], [URLTYPE], [VERSION], [SYSTEM], [LABEL], [SHOWWAY], [CREATOR], [REVISER], [CREATE_DATE], [MODIFY_DATE], [APP_NAME2], [APP_NAME3], [APP_NAME4], [APP_NAME5], [APP_NAME6]) VALUES ('2928822db89c433184c04957b6f1fe6f', '一主多子', '', '6c173e474f3742a1b70960f4e1cca4df', '646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/masterdetail-many#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'masterdetail-many', NULL, 'tenant', 'url', '2', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:43:59.980', NULL, 'masterdetail-many', '一主多子', NULL, NULL, NULL);
GO
GO
INSERT INTO [WB_APP_APPS] ([ID], [APP_NAME], [APP_INDEX], [GROUP_ID], [DOMAIN_ID], [URL], [APP_CHINESE], [APP_DESC], [APP_ICON], [APP_GROUPCODE], [APP_CODE], [DYNA_URL], [TENANT_ID], [URLTYPE], [VERSION], [SYSTEM], [LABEL], [SHOWWAY], [CREATOR], [REVISER], [CREATE_DATE], [MODIFY_DATE], [APP_NAME2], [APP_NAME3], [APP_NAME4], [APP_NAME5], [APP_NAME6]) VALUES ('9b03021ef646490499af7bfd2e42a1bc', '左树右表', '', '6c173e474f3742a1b70960f4e1cca4df', '646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/tree#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'tree', NULL, 'tenant', 'url', '1', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:50:59.687', NULL, 'tree', '左樹右表', NULL, NULL, NULL);
GO
GO
INSERT INTO [WB_APP_APPS] ([ID], [APP_NAME], [APP_INDEX], [GROUP_ID], [DOMAIN_ID], [URL], [APP_CHINESE], [APP_DESC], [APP_ICON], [APP_GROUPCODE], [APP_CODE], [DYNA_URL], [TENANT_ID], [URLTYPE], [VERSION], [SYSTEM], [LABEL], [SHOWWAY], [CREATOR], [REVISER], [CREATE_DATE], [MODIFY_DATE], [APP_NAME2], [APP_NAME3], [APP_NAME4], [APP_NAME5], [APP_NAME6]) VALUES ('a68b611de88d40b7869fbdec63fa15e9', '行内编辑', '', '6c173e474f3742a1b70960f4e1cca4df', '646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/singletable-inline-edit#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'singletable-inlineEdit', NULL, 'tenant', 'url', '2', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:47:08.727', NULL, 'singletable-inlineEdit', '行內編輯', NULL, NULL, NULL);
GO
GO
INSERT INTO [WB_APP_APPS] ([ID], [APP_NAME], [APP_INDEX], [GROUP_ID], [DOMAIN_ID], [URL], [APP_CHINESE], [APP_DESC], [APP_ICON], [APP_GROUPCODE], [APP_CODE], [DYNA_URL], [TENANT_ID], [URLTYPE], [VERSION], [SYSTEM], [LABEL], [SHOWWAY], [CREATOR], [REVISER], [CREATE_DATE], [MODIFY_DATE], [APP_NAME2], [APP_NAME3], [APP_NAME4], [APP_NAME5], [APP_NAME6]) VALUES ('f3efaf3a6caa443baa52ba762345a56e', '单表查询', '', '6c173e474f3742a1b70960f4e1cca4df', '646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/singletable-query#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'singletable-query', NULL, 'tenant', 'url', '1', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:49:20.797', NULL, 'singletable-query', '單表查詢', NULL, NULL, NULL);
GO
GO
-- ----------------------------
-- Records of WB_LABEL_RELATION
-- ----------------------------
-- INSERT INTO [WB_LABEL_RELATION] ([ID], [LABELCODE], [SOURCECODE], [CREATE_DATE], [TENANT_ID], [SYSTEM], [LABLEID], [SOURCEID], [TYPE]) VALUES ('ea85e2865aa94db29ba84de477230752', 'buisource', 'ygdemo_yw_info', NULL, 'tenant', NULL, NULL, '27228e888fc34440835fec75f8fe57b7', 'app');
-- GO
GO
INSERT INTO [WB_LABEL_RELATION] ([ID], [LABELCODE], [SOURCECODE], [CREATE_DATE], [TENANT_ID], [SYSTEM], [LABLEID], [SOURCEID], [TYPE]) VALUES ('1924e837be834dfe8dff8747ac7b97b6', 'buisource', 'singletable-query', '2018-12-06 20:49:20.797', 'tenant', NULL, NULL, 'f3efaf3a6caa443baa52ba762345a56e', 'app');
GO
GO
INSERT INTO [WB_LABEL_RELATION] ([ID], [LABELCODE], [SOURCECODE], [CREATE_DATE], [TENANT_ID], [SYSTEM], [LABLEID], [SOURCEID], [TYPE]) VALUES ('253bd6db452c4ce4aa2bd7ca553d456c', 'buisource', 'singletable-grouping', '2018-12-06 20:46:10.600', 'tenant', NULL, NULL, '1e64fafeb734479aba2509827dfe06e8', 'app');
GO
GO
INSERT INTO [WB_LABEL_RELATION] ([ID], [LABELCODE], [SOURCECODE], [CREATE_DATE], [TENANT_ID], [SYSTEM], [LABLEID], [SOURCEID], [TYPE]) VALUES ('3ec6d1976c5e4ba8aafc481836705cc5', 'buisource', 'singletable-viewtemplate', '2018-12-06 20:50:08.277', 'tenant', NULL, NULL, 'f86f96e553e74a33a06c5ac69d4e9c45', 'app');
GO
GO
INSERT INTO [WB_LABEL_RELATION] ([ID], [LABELCODE], [SOURCECODE], [CREATE_DATE], [TENANT_ID], [SYSTEM], [LABLEID], [SOURCEID], [TYPE]) VALUES ('430afbb6325a4583a5a71920baa5be1a', 'buisource', 'tree', '2018-12-06 20:50:59.687', 'tenant', NULL, NULL, '9b03021ef646490499af7bfd2e42a1bc', 'app');
GO
GO
INSERT INTO [WB_LABEL_RELATION] ([ID], [LABELCODE], [SOURCECODE], [CREATE_DATE], [TENANT_ID], [SYSTEM], [LABLEID], [SOURCEID], [TYPE]) VALUES ('bc664a4e20a641af988c5322dd43aed8', 'buisource', 'singletable-inlineEdit', '2018-12-06 20:47:08.727', 'tenant', NULL, NULL, 'a68b611de88d40b7869fbdec63fa15e9', 'app');
GO
GO
INSERT INTO [WB_LABEL_RELATION] ([ID], [LABELCODE], [SOURCECODE], [CREATE_DATE], [TENANT_ID], [SYSTEM], [LABLEID], [SOURCEID], [TYPE]) VALUES ('d4c276b8a38842899f0d6785261d7633', 'buisource', 'masterdetail-one', '2018-12-06 20:45:01.997', 'tenant', NULL, NULL, '00e601475c6c471aa2cd2250bbcc7ff1', 'app');
GO
GO
INSERT INTO [WB_LABEL_RELATION] ([ID], [LABELCODE], [SOURCECODE], [CREATE_DATE], [TENANT_ID], [SYSTEM], [LABLEID], [SOURCEID], [TYPE]) VALUES ('e406e4eac7ec41c88b09418d24608b8c', 'buisource', 'singletable-popupedit', '2018-12-06 20:48:19.413', 'tenant', NULL, NULL, '1e1573e4a3574e6bb5e8be60f164a6ee', 'app');
GO
GO
INSERT INTO [WB_LABEL_RELATION] ([ID], [LABELCODE], [SOURCECODE], [CREATE_DATE], [TENANT_ID], [SYSTEM], [LABLEID], [SOURCEID], [TYPE]) VALUES ('f3f02e97a7314e1293c3c22cc2eb0e9c', 'buisource', 'masterdetail-many', '2018-12-06 20:48:19.413', 'tenant', NULL, NULL, '2928822db89c433184c04957b6f1fe6f', 'app');
GO
GO
-- ----------------------------
-- Records of IEOP_FUNCTION
-- ----------------------------
-- INSERT INTO [IEOP_FUNCTION] ([ID], [FUNC_NAME], [FUNC_CODE], [FUNC_TYPE], [FUNC_URL], [ISCONTROL], [ISACTIVE], [CREATE_DATE], [ISLEAF], [PARENT_ID], [TENANT_ID], [SYS_ID], [ENABLEACTION], [CREATOR], [MENU_URL], [FUNC_NAME2], [FUNC_NAME3], [FUNC_NAME4], [FUNC_NAME5], [FUNC_NAME6]) VALUES ('27228e888fc34440835fec75f8fe57b7', '督办任务', 'ygdemo_yw_info', 'N', '/example/ygdemo_yw_info/', 'Y', 'Y', null, 'N', 'ROOT', 'tenant', 'wbalone', 'Y', null, '/example/pages/ygdemo_yw_info/ygdemo_yw_info.js', 'Supervising Task', '督辦任務', null, null, null);
INSERT INTO [IEOP_FUNCTION] ([ID], [FUNC_NAME], [FUNC_CODE], [FUNC_TYPE], [FUNC_URL], [ISCONTROL], [ISACTIVE], [CREATE_DATE], [ISLEAF], [PARENT_ID], [TENANT_ID], [SYS_ID], [ENABLEACTION], [CREATOR], [MENU_URL], [FUNC_NAME2], [FUNC_NAME3], [FUNC_NAME4], [FUNC_NAME5], [FUNC_NAME6]) VALUES ('00e601475c6c471aa2cd2250bbcc7ff1', '一主一子', 'masterdetail-one', 'N', '/iuap-pap-demo-be/purchase_order,/iuap-pap-demo-be/purchase_order_detail', 'Y', 'Y', null, 'N', 'ROOT', 'tenant', 'wbalone', 'Y', null, '/iuap-pap-demo-fe/masterdetail-one#/', 'masterdetail-one', '一主一子', null, null, null);
INSERT INTO [IEOP_FUNCTION] ([ID], [FUNC_NAME], [FUNC_CODE], [FUNC_TYPE], [FUNC_URL], [ISCONTROL], [ISACTIVE], [CREATE_DATE], [ISLEAF], [PARENT_ID], [TENANT_ID], [SYS_ID], [ENABLEACTION], [CREATOR], [MENU_URL], [FUNC_NAME2], [FUNC_NAME3], [FUNC_NAME4], [FUNC_NAME5], [FUNC_NAME6]) VALUES ('2928822db89c433184c04957b6f1fe6f', '一主多子', 'masterdetail-many', 'N', '/iuap-pap-demo-be/passenger,/iuap-pap-demo-be/emergency_contact,/iuap-pap-demo-be/traveling_information', 'Y', 'Y', null, 'N', 'ROOT', 'tenant', 'wbalone', 'Y', null, '/iuap-pap-demo-fe/masterdetail-many#/', 'masterdetail-many', '一主多子', null, null, null);
INSERT INTO [IEOP_FUNCTION] ([ID], [FUNC_NAME], [FUNC_CODE], [FUNC_TYPE], [FUNC_URL], [ISCONTROL], [ISACTIVE], [CREATE_DATE], [ISLEAF], [PARENT_ID], [TENANT_ID], [SYS_ID], [ENABLEACTION], [CREATOR], [MENU_URL], [FUNC_NAME2], [FUNC_NAME3], [FUNC_NAME4], [FUNC_NAME5], [FUNC_NAME6]) VALUES ('9b03021ef646490499af7bfd2e42a1bc', '左树右表', 'tree', 'N', '/iuap-pap-demo-be/tree_demo,/iuap-pap-demo-be/table_demo', 'Y', 'Y', null, 'N', 'ROOT', 'tenant', 'wbalone', 'Y', null, '/iuap-pap-demo-fe/tree#/', 'tree', '左樹右表', null, null, null);
INSERT INTO IEOP_FUNCTION (ID, FUNC_NAME, FUNC_CODE, FUNC_TYPE, FUNC_URL, ISCONTROL, ISACTIVE, CREATE_DATE, ISLEAF, PARENT_ID, TENANT_ID, SYS_ID, ENABLEACTION, CREATOR, MENU_URL, FUNC_NAME2, FUNC_NAME3, FUNC_NAME4, FUNC_NAME5, FUNC_NAME6) VALUES ('f3efaf3a6caa443baa52ba762345a56e', '单表查询', 'singletable-query', 'N', '/iuap-pap-demo-be/query_allowances', 'Y', 'Y', NULL, 'N', 'ROOT', 'tenant', 'wbalone', 'Y', NULL, '/iuap-pap-demo-fe/singletable-query#/', 'singletable-query', '單表查詢', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION (ID, FUNC_NAME, FUNC_CODE, FUNC_TYPE, FUNC_URL, ISCONTROL, ISACTIVE, CREATE_DATE, ISLEAF, PARENT_ID, TENANT_ID, SYS_ID, ENABLEACTION, CREATOR, MENU_URL, FUNC_NAME2, FUNC_NAME3, FUNC_NAME4, FUNC_NAME5, FUNC_NAME6) VALUES ('1e1573e4a3574e6bb5e8be60f164a6ee', '弹框编辑', 'singletable-popupedit', 'N', '/iuap-pap-demo-be/popup_allowances', 'Y', 'Y', NULL, 'N', 'ROOT', 'tenant', 'wbalone', 'Y', NULL, '/iuap-pap-demo-fe/singletable-popup-edit#/', 'singletable-popupedit', '彈框編輯', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION (ID, FUNC_NAME, FUNC_CODE, FUNC_TYPE, FUNC_URL, ISCONTROL, ISACTIVE, CREATE_DATE, ISLEAF, PARENT_ID, TENANT_ID, SYS_ID, ENABLEACTION, CREATOR, MENU_URL, FUNC_NAME2, FUNC_NAME3, FUNC_NAME4, FUNC_NAME5, FUNC_NAME6) VALUES ('a68b611de88d40b7869fbdec63fa15e9', '行内编辑', 'singletable-inlineEdit', 'N', '/iuap-pap-demo-be/inline_allowances', 'Y', 'Y', NULL, 'N', 'ROOT', 'tenant', 'wbalone', 'Y', NULL, '/iuap-pap-demo-fe/singletable-inline-edit#/', 'singletable-inlineEdit', '行內編輯', NULL, NULL, NULL);
GO
-- ----------------------------
-- Records of WB_APP_MENU
-- ----------------------------
INSERT INTO [WB_APP_MENU] ([ID], [FUNC_ID], [ICON], [ISENABLE], [ISVISIBLE], [IS_VIRTUAL_NODE], [PARENT_ID], [CLASSIFY], [LAYOUT_ID], [SORT], [CREATE_TIME], [NAME], [TENANT_ID], [VERSION], [LABEL], [TS], [DR], [OPENVIEW], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('d2f8a0b7751a453d9e8d7e3cc3aceb62', 'example', 'grey iconfont icon-appicon', 'Y', 'Y', 'Y', 'M0000000000001', NULL, 'null', '1', '2018-12-06 20:52:19.687', '开发示例', 'tenant', '1', NULL, NULL, NULL, 'curnpage', 'walsin', '開發示例', 'null', 'null', 'null');
-- INSERT INTO [WB_APP_MENU] ([ID], [FUNC_ID], [ICON], [ISENABLE], [ISVISIBLE], [IS_VIRTUAL_NODE], [PARENT_ID], [CLASSIFY], [LAYOUT_ID], [SORT], [CREATE_TIME], [NAME], [TENANT_ID], [VERSION], [LABEL], [TS], [DR], [OPENVIEW], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('183f1f0071b0464e9190df1e5386e7e4', 'UUI', 'grey iconfont icon-appicon', 'Y', 'Y', 'Y', 'd2f8a0b7751a453d9e8d7e3cc3aceb62', NULL, 'null', '2', '2018-12-12 13:27:32.767', 'UUI', 'tenant', '0', 'common', NULL, NULL, 'curnpage', 'UUI', 'UUI', NULL, NULL, NULL);
INSERT INTO [WB_APP_MENU] ([ID], [FUNC_ID], [ICON], [ISENABLE], [ISVISIBLE], [IS_VIRTUAL_NODE], [PARENT_ID], [CLASSIFY], [LAYOUT_ID], [SORT], [CREATE_TIME], [NAME], [TENANT_ID], [VERSION], [LABEL], [TS], [DR], [OPENVIEW], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('e238812395b647969d77be13757abb1e', 'React', ' iconfont icon-appicon ', 'Y', 'Y', 'Y', 'd2f8a0b7751a453d9e8d7e3cc3aceb62', NULL, 'null', '1', '2018-12-12 13:28:08.483', 'React', 'tenant', '0', 'common', NULL, NULL, 'curnpage', 'React', 'React', NULL, NULL, NULL);

-- INSERT INTO [WB_APP_MENU] ([ID], [FUNC_ID], [ICON], [ISENABLE], [ISVISIBLE], [IS_VIRTUAL_NODE], [PARENT_ID], [CLASSIFY], [LAYOUT_ID], [SORT], [CREATE_TIME], [NAME], [TENANT_ID], [VERSION], [LABEL], [TS], [DR], [OPENVIEW], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('8af3f8cc84774297b2b2d08b9425f851', 'demo01', ' iconfont icon-appicon ', 'Y', 'Y', 'N', '183f1f0071b0464e9190df1e5386e7e4', NULL, 'ygdemo_yw_info', '1', cast('2018-04-26 14:23:51' as datetime), '督办任务', 'tenant', '0', 'common', NULL, NULL, 'curnpage','Supervising Task','督辦任務','','','');
INSERT INTO [WB_APP_MENU] ([ID], [FUNC_ID], [ICON], [ISENABLE], [ISVISIBLE], [IS_VIRTUAL_NODE], [PARENT_ID], [CLASSIFY], [LAYOUT_ID], [SORT], [CREATE_TIME], [NAME], [TENANT_ID], [VERSION], [LABEL], [TS], [DR], [OPENVIEW], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('22ee86794c0b4dc7b26779a7b0135a12', 'singletable-inlineEdit', ' iconfont icon-appicon ', 'Y', 'Y', 'N', 'e238812395b647969d77be13757abb1e', NULL, 'singletable-inlineEdit', '2', '2018-12-06 20:53:33.577', 'A2单表行内编辑', 'tenant', '1', NULL, NULL, NULL, 'curnpage', 'singletable-inlineEdit', 'A2單表行內編輯', 'null', 'null', 'null');
INSERT INTO [WB_APP_MENU] ([ID], [FUNC_ID], [ICON], [ISENABLE], [ISVISIBLE], [IS_VIRTUAL_NODE], [PARENT_ID], [CLASSIFY], [LAYOUT_ID], [SORT], [CREATE_TIME], [NAME], [TENANT_ID], [VERSION], [LABEL], [TS], [DR], [OPENVIEW], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('2d2e26ba95f542cf9adb7811168c5377', 'tree', ' iconfont icon-appicon ', 'Y', 'Y', 'N', 'e238812395b647969d77be13757abb1e', NULL, 'tree', '4', '2018-12-06 20:54:51.367', 'B1左树右表', 'tenant', '1', NULL, NULL, NULL, 'curnpage', 'tree', 'B1左樹右表', 'null', 'null', 'null');
INSERT INTO [WB_APP_MENU] ([ID], [FUNC_ID], [ICON], [ISENABLE], [ISVISIBLE], [IS_VIRTUAL_NODE], [PARENT_ID], [CLASSIFY], [LAYOUT_ID], [SORT], [CREATE_TIME], [NAME], [TENANT_ID], [VERSION], [LABEL], [TS], [DR], [OPENVIEW], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('5355a23b52f44b219cff084e28fa9dc9', 'singletable-query', ' iconfont icon-appicon ', 'Y', 'Y', 'N', 'e238812395b647969d77be13757abb1e', NULL, 'singletable-query', '1', '2018-12-06 20:52:59.180', 'A1单表查询', 'tenant', '1', NULL, NULL, NULL, 'curnpage', 'singletable-query', 'A1單表查詢', 'null', 'null', 'null');
INSERT INTO [WB_APP_MENU] ([ID], [FUNC_ID], [ICON], [ISENABLE], [ISVISIBLE], [IS_VIRTUAL_NODE], [PARENT_ID], [CLASSIFY], [LAYOUT_ID], [SORT], [CREATE_TIME], [NAME], [TENANT_ID], [VERSION], [LABEL], [TS], [DR], [OPENVIEW], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('592593f078e54639a648b8e2f71b98bd', 'masterdetail-many', ' iconfont icon-appicon ', 'Y', 'Y', 'N', 'e238812395b647969d77be13757abb1e', NULL, 'masterdetail-many', '6', '2018-12-06 20:55:48.663', 'B3一主多子', 'tenant', '1', NULL, NULL, NULL, 'curnpage', 'masterdetail-many', 'B3一主多子', 'null', 'null', 'null');
INSERT INTO [WB_APP_MENU] ([ID], [FUNC_ID], [ICON], [ISENABLE], [ISVISIBLE], [IS_VIRTUAL_NODE], [PARENT_ID], [CLASSIFY], [LAYOUT_ID], [SORT], [CREATE_TIME], [NAME], [TENANT_ID], [VERSION], [LABEL], [TS], [DR], [OPENVIEW], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('802be413f3254d49aab0a24b0603c973', 'singletable-popupedit', ' iconfont icon-appicon ', 'Y', 'Y', 'N', 'e238812395b647969d77be13757abb1e', NULL, 'singletable-popupedit', '3', '2018-12-06 20:54:12.340', 'A3单表弹窗编辑', 'tenant', '2', NULL, NULL, NULL, 'curnpage', 'singletable-popupedit', 'A3單表彈窗編輯', 'null', 'null', 'null');
INSERT INTO [WB_APP_MENU] ([ID], [FUNC_ID], [ICON], [ISENABLE], [ISVISIBLE], [IS_VIRTUAL_NODE], [PARENT_ID], [CLASSIFY], [LAYOUT_ID], [SORT], [CREATE_TIME], [NAME], [TENANT_ID], [VERSION], [LABEL], [TS], [DR], [OPENVIEW], [NAME2], [NAME3], [NAME4], [NAME5], [NAME6]) VALUES ('c129091db54f4506987109754f4bdaff', 'masterdetail-one', ' iconfont icon-appicon ', 'Y', 'Y', 'N', 'e238812395b647969d77be13757abb1e', NULL, 'masterdetail-one', '5', '2018-12-06 20:55:22.603', 'B2一主一子', 'tenant', '1', NULL, NULL, NULL, 'curnpage', 'masterdetail-one', 'B2一主一子', 'null', 'null', 'null');
GO
GO
-- ----------------------------
-- Records of IEOP_FUNCTION_ACTIVITY
-- ----------------------------
-- INSERT INTO [IEOP_FUNCTION_ACTIVITY] ([ID], [ACTIVITY_NAME], [ACTIVITY_CODE], [ACTIVITY_URL], [FUNC_ID], [ISACTIVE], [CREATE_DATE], [SYS_ID], [TENANT_ID], [ACTIVITY_NAME2], [ACTIVITY_NAME3], [ACTIVITY_NAME4], [ACTIVITY_NAME5], [ACTIVITY_NAME6]) VALUES ('7a29fa4f651f4850b29e2e337147280d', '修改', 'update', '/ygdemo_yw_info/update', '27228e888fc34440835fec75f8fe57b7', 'Y', null, 'wbalone', 'tenant', 'Modify', '修改', null, null, null);
-- INSERT INTO [IEOP_FUNCTION_ACTIVITY] ([ID], [ACTIVITY_NAME], [ACTIVITY_CODE], [ACTIVITY_URL], [FUNC_ID], [ISACTIVE], [CREATE_DATE], [SYS_ID], [TENANT_ID], [ACTIVITY_NAME2], [ACTIVITY_NAME3], [ACTIVITY_NAME4], [ACTIVITY_NAME5], [ACTIVITY_NAME6]) VALUES ('be3c3323e42d46e7a393c3b0613457b3', '新增', 'add', '/ygdemo_yw_info/add', '27228e888fc34440835fec75f8fe57b7', 'Y', null, 'wbalone', 'tenant', 'New', '新增', null, null, null);
-- INSERT INTO [IEOP_FUNCTION_ACTIVITY] ([ID], [ACTIVITY_NAME], [ACTIVITY_CODE], [ACTIVITY_URL], [FUNC_ID], [ISACTIVE], [CREATE_DATE], [SYS_ID], [TENANT_ID], [ACTIVITY_NAME2], [ACTIVITY_NAME3], [ACTIVITY_NAME4], [ACTIVITY_NAME5], [ACTIVITY_NAME6]) VALUES ('f7f0917ae6ef486fb6aad80e744517a3', '删除', 'delete', '/ygdemo_yw_info/delete', '27228e888fc34440835fec75f8fe57b7', 'Y', null, 'wbalone', 'tenant', 'Delete', '刪除', null, null, null);

-- INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('06fd431b824a4fe3b8ddc057ef8cf314', '详情', 'check', '/purchase_order/getAssoVo', '00e601475c6c471aa2cd2250bbcc7ff1', 'Y', NULL, 'wbalone', 'tenant', 'check', '詳情', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('1bf819b5fdf8403aabdfb46d902443af', '删除tr', 'delete_tr', '/traveling_information/deleteBatch', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'delete_tr', '刪除tr', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('1cc2c2b68d6d444f8ab82efee52cf45a', '详情', 'check', '/inline_allowances/list', 'a68b611de88d40b7869fbdec63fa15e9', 'Y', NULL, 'wbalone', 'tenant', 'check', '詳情', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('2cb772bd2dea4900bde1c13ef331066b', '新增em', 'add_em', '/emergency_contact/insertSelective', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'add_em', '新增em', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('2cd535bf7d494467b5b1c471cdad6a0b', '新增', 'add', '/popup_allowances/insertSelective', '1e1573e4a3574e6bb5e8be60f164a6ee', 'Y', NULL, 'wbalone', 'tenant', 'add', '新增', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('2dc6e7dc94b84a3ea984d22546a0140a', '详情', 'check', '/table_demo/list', '9b03021ef646490499af7bfd2e42a1bc', 'Y', NULL, 'wbalone', 'tenant', 'check', '詳情', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('326ac364d5274c839d9bc323426e5447', '新增', 'add', '/passenger/insertSelective', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'add', '新增', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('4b7bcf27758e4fd9808f30baca119985', '修改', 'update', '/purchase_order/updateAssoVo', '00e601475c6c471aa2cd2250bbcc7ff1', 'Y', NULL, 'wbalone', 'tenant', 'update', '修改', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('4e568299dc884405a7e7e9aedf01711c', '删除', 'delete', '/popup_allowances/deleteBatch', '1e1573e4a3574e6bb5e8be60f164a6ee', 'Y', NULL, 'wbalone', 'tenant', 'delete', '刪除', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('571c1124e86049f5b3e2a1fed7d6b8b3', '新增', 'add', '/purchase_order/saveAssoVo', '00e601475c6c471aa2cd2250bbcc7ff1', 'Y', NULL, 'wbalone', 'tenant', 'add', '新增', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('792bef6886b64da691be2e11ee07d285', '修改', 'update', '/table_demo/updateSelective', '9b03021ef646490499af7bfd2e42a1bc', 'Y', NULL, 'wbalone', 'tenant', 'update', '修改', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('8c307c88426b4f18b27c65a64501d746', '新增', 'add', '/inline_allowances/insertSelective', 'a68b611de88d40b7869fbdec63fa15e9', 'Y', NULL, 'wbalone', 'tenant', 'add', '新增', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('8ea4dd3f92184315bf59fc745017039c', '删除em', 'delete_em', '/emergency_contact/deleteBatch', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'delete_em', '刪除em', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('9cb5c7e59e2c44e99f86e0c7232ba742', '新增tr', 'add_tr', '/traveling_information/insertSelective', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'add_tr', '新增tr', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('a3471008814b41e5aba077ba310a5c20', '修改tr', 'update_tr', '/traveling_information/updateSelective', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'update_tr', '修改tr', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('a393f919ba9640ffac39798109984278', '修改', 'update', '/passenger/updateSelective', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'update', '修改', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('aa74b7d81f024cfca0038cdd88f4b799', '详情em', 'check_em', '/emergency_contact/list', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'check_em', '詳情em', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('adf710afbb884c2ab495098254de49c5', '删除', 'delete', '/purchase_order/deleteBatch', '00e601475c6c471aa2cd2250bbcc7ff1', 'Y', NULL, 'wbalone', 'tenant', 'delete', '刪除', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('beba9692b84f4d6e981d95ea4d35b3ef', '详情', 'check', '/passenger/list', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'check', '詳情', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('bfac5913447d4367bc6d2f5f87de5e4f', '修改', 'update', '/inline_allowances/updateSelective', 'a68b611de88d40b7869fbdec63fa15e9', 'Y', NULL, 'wbalone', 'tenant', 'update', '修改', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('c15008a829d7443aaa3fbbd37e17581c', '新增', 'add', '/table_demo/insertSelective', '9b03021ef646490499af7bfd2e42a1bc', 'Y', NULL, 'wbalone', 'tenant', 'add', '新增', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('c30209cdb318415897940e96025b7e7a', '删除', 'delete', '/table_demo/deleteBatch', '9b03021ef646490499af7bfd2e42a1bc', 'Y', NULL, 'wbalone', 'tenant', 'delete', '刪除', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('c6c588de675f4400a045fd21a8690c3a', '详情tr', 'check_tr', '/traveling_information/list', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'check_tr', '詳情tr', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('d33ee12e6d3a4b729224e7c26c892cf5', '修改em', 'update_em', '/emergency_contact/updateSelective', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'update_em', '修改em', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('d4cd90dbdec343b499df11f5123ebd01', '删除', 'delete', '/inline_allowances/deleteBatch', 'a68b611de88d40b7869fbdec63fa15e9', 'Y', NULL, 'wbalone', 'tenant', 'delete', '刪除', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('d592f92cbc394d9faab809f86492dbd2', '删除', 'delete', '/passenger/deleteBatch', '2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'tenant', 'delete', '刪除', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('e2811e0c075a410e841e1a913f7041d3', '修改', 'update', '/popup_allowances/updateSelective', '1e1573e4a3574e6bb5e8be60f164a6ee', 'Y', NULL, 'wbalone', 'tenant', 'update', '修改', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('e5f8d2697bb543b5bec815110bcdbd49', '详情', 'check', '/popup_allowances/list', '1e1573e4a3574e6bb5e8be60f164a6ee', 'Y', NULL, 'wbalone', 'tenant', 'check', '詳情', NULL, NULL, NULL);
GO
-- ----------------------------
-- Records of IEOP_ROLE_PERMISSION
-- ----------------------------
GO
-- INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000099', 'R001', 'admin', '27228e888fc34440835fec75f8fe57b7', 'ygdemo_yw_info', '1', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000100', 'R001', 'admin', '00e601475c6c471aa2cd2250bbcc7ff1', 'masterdetail-one', '1', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000101', 'R001', 'admin', '1e1573e4a3574e6bb5e8be60f164a6ee', 'singletable-popupedit', '1', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000102', 'R001', 'admin', '2928822db89c433184c04957b6f1fe6f', 'masterdetail-many', '1', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000103', 'R001', 'admin', '9b03021ef646490499af7bfd2e42a1bc', 'tree', '1', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000104', 'R001', 'admin', 'a68b611de88d40b7869fbdec63fa15e9', 'singletable-inlineEdit', '1', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000105', 'R001', 'admin', 'f3efaf3a6caa443baa52ba762345a56e', 'singletable-query', '1', 'tenant', 'wbalone');

INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000200', 'R001', 'admin', '06fd431b824a4fe3b8ddc057ef8cf314', '/PURCHASE_ORDER/getAssoVo', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000201', 'R001', 'admin', '1bf819b5fdf8403aabdfb46d902443af', '/TRAVELING_INFORMATION/deleteBatch', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000202', 'R001', 'admin', '1cc2c2b68d6d444f8ab82efee52cf45a', '/ALLOWANCES/list', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000203', 'R001', 'admin', '2cb772bd2dea4900bde1c13ef331066b', '/EMERGENCY_CONTACT/insertSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000204', 'R001', 'admin', '2cd535bf7d494467b5b1c471cdad6a0b', '/ALLOWANCES/insertSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000205', 'R001', 'admin', '2dc6e7dc94b84a3ea984d22546a0140a', '/TABLE_DEMO/list', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000206', 'R001', 'admin', '326ac364d5274c839d9bc323426e5447', '/PASSENGER/insertSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000207', 'R001', 'admin', '4b7bcf27758e4fd9808f30baca119985', '/PURCHASE_ORDER/updateAssoVo', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000208', 'R001', 'admin', '4e568299dc884405a7e7e9aedf01711c', '/ALLOWANCES/deleteBatch', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000209', 'R001', 'admin', '571c1124e86049f5b3e2a1fed7d6b8b3', '/PURCHASE_ORDER/saveAssoVo', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000210', 'R001', 'admin', '792bef6886b64da691be2e11ee07d285', '/TABLE_DEMO/updateSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000211', 'R001', 'admin', '8c307c88426b4f18b27c65a64501d746', '/ALLOWANCES/insertSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000212', 'R001', 'admin', '8ea4dd3f92184315bf59fc745017039c', '/EMERGENCY_CONTACT/deleteBatch', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000213', 'R001', 'admin', '9cb5c7e59e2c44e99f86e0c7232ba742', '/TRAVELING_INFORMATION/insertSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000214', 'R001', 'admin', 'a3471008814b41e5aba077ba310a5c20', '/TRAVELING_INFORMATION/updateSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000215', 'R001', 'admin', 'a393f919ba9640ffac39798109984278', '/PASSENGER/updateSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000216', 'R001', 'admin', 'aa74b7d81f024cfca0038cdd88f4b799', '/EMERGENCY_CONTACT/list', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000217', 'R001', 'admin', 'adf710afbb884c2ab495098254de49c5', '/PURCHASE_ORDER/deleteBatch', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000218', 'R001', 'admin', 'beba9692b84f4d6e981d95ea4d35b3ef', '/PASSENGER/list', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000219', 'R001', 'admin', 'bfac5913447d4367bc6d2f5f87de5e4f', '/ALLOWANCES/updateSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000220', 'R001', 'admin', 'c15008a829d7443aaa3fbbd37e17581c', '/TABLE_DEMO/insertSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000221', 'R001', 'admin', 'c30209cdb318415897940e96025b7e7a', '/TABLE_DEMO/deleteBatch', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000222', 'R001', 'admin', 'c6c588de675f4400a045fd21a8690c3a', '/TRAVELING_INFORMATION/list', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000223', 'R001', 'admin', 'd33ee12e6d3a4b729224e7c26c892cf5', '/EMERGENCY_CONTACT/updateSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000224', 'R001', 'admin', 'd4cd90dbdec343b499df11f5123ebd01', '/ALLOWANCES/deleteBatch', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000225', 'R001', 'admin', 'd592f92cbc394d9faab809f86492dbd2', '/PASSENGER/deleteBatch', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000226', 'R001', 'admin', 'e2811e0c075a410e841e1a913f7041d3', '/ALLOWANCES/updateSelective', 'action', 'tenant', 'wbalone');
INSERT INTO [IEOP_ROLE_PERMISSION] ([ID], [ROLE_ID], [ROLE_CODE], [PERMISSION_ID], [PERMISSION_CODE], [PERMISSION_TYPE], [TENANT_ID], [SYS_ID]) VALUES ('PERMI00000227', 'R001', 'admin', 'e5f8d2697bb543b5bec815110bcdbd49', '/ALLOWANCES/list', 'action', 'tenant', 'wbalone');
GO

-- ----------------------------
-- Records of IUAPD_RANKS
-- ----------------------------
INSERT INTO [IUAPD_RANKS] ([ID], [CODE], [TYPE],[TYPE2],[TYPE3],[TYPE4],[TYPE5],[TYPE6], [GRADE], [POST_LEVEL],[POST_LEVEL2],[POST_LEVEL3],[POST_LEVEL4],[POST_LEVEL5],[POST_LEVEL6], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID]) VALUES (N'level1', N'T1', N'技术',N'technique',N'技術',N'',N'',N'', N'1', N'初级',N'primary',N'初級',N'',N'',N'', N'', N'', N'', N'', N'', N'1', N'0', N'tenant');
INSERT INTO [IUAPD_RANKS] ([ID], [CODE], [TYPE],[TYPE2],[TYPE3],[TYPE4],[TYPE5],[TYPE6], [GRADE], [POST_LEVEL],[POST_LEVEL2],[POST_LEVEL3],[POST_LEVEL4],[POST_LEVEL5],[POST_LEVEL6], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID]) VALUES (N'level2', N'M1', N'管理',N'management',N'管理',N'',N'',N'',N'1', N'初级',N'primary',N'初級',N'',N'',N'', N'', N'', N'', N'', N'', N'1', N'0', N'tenant');
INSERT INTO [IUAPD_RANKS] ([ID], [CODE], [TYPE],[TYPE2],[TYPE3],[TYPE4],[TYPE5],[TYPE6], [GRADE], [POST_LEVEL],[POST_LEVEL2],[POST_LEVEL3],[POST_LEVEL4],[POST_LEVEL5],[POST_LEVEL6], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID]) VALUES (N'level3', N'T2', N'技术',N'technique',N'技術',N'',N'',N'', N'2', N'中级',N'intermediate',N'中級',N'',N'',N'', N'', N'', N'', N'', N'', N'1', N'0', N'tenant');
INSERT INTO [IUAPD_RANKS] ([ID], [CODE], [TYPE],[TYPE2],[TYPE3],[TYPE4],[TYPE5],[TYPE6], [GRADE], [POST_LEVEL],[POST_LEVEL2],[POST_LEVEL3],[POST_LEVEL4],[POST_LEVEL5],[POST_LEVEL6], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID]) VALUES (N'level4', N'M2', N'管理',N'management',N'管理',N'',N'',N'',N'2', N'中级',N'intermediate',N'中級',N'',N'',N'', N'', N'', N'', N'', N'', N'1', N'0', N'tenant');
INSERT INTO [IUAPD_RANKS] ([ID], [CODE], [TYPE],[TYPE2],[TYPE3],[TYPE4],[TYPE5],[TYPE6], [GRADE], [POST_LEVEL],[POST_LEVEL2],[POST_LEVEL3],[POST_LEVEL4],[POST_LEVEL5],[POST_LEVEL6], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID]) VALUES (N'level5', N'T3', N'技术',N'technique',N'技術',N'',N'',N'', N'3', N'高级',N'senior',N'高級',N'',N'',N'', N'', N'', N'', N'', N'', N'1', N'0', N'tenant');
INSERT INTO [IUAPD_RANKS] ([ID], [CODE], [TYPE],[TYPE2],[TYPE3],[TYPE4],[TYPE5],[TYPE6], [GRADE], [POST_LEVEL],[POST_LEVEL2],[POST_LEVEL3],[POST_LEVEL4],[POST_LEVEL5],[POST_LEVEL6], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID]) VALUES (N'level6', N'M3', N'管理',N'management',N'管理',N'',N'',N'',N'3', N'高级',N'senior',N'高級',N'',N'',N'', N'', N'', N'', N'', N'', N'1', N'0', N'tenant');
GO

INSERT INTO [IUAPD_TREELIST] ([ID], [NAME], [IS_SON], [PARENTID], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID], [CODE]) VALUES ('a7fd55cb0bfd4a28a560a29c65b00001', '测试1', '2', '0', '', '', '2018-11-06 08:40:03 874', 'e4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'tenant', '0001');
INSERT INTO [IUAPD_TREELIST] ([ID], [NAME], [IS_SON], [PARENTID], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID], [CODE]) VALUES ('a7fd55cb0bfd4a28a560a29c65b00101', '测试1_1', '1', 'a7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'e4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'tenant', '00010001');
INSERT INTO [IUAPD_TREELIST] ([ID], [NAME], [IS_SON], [PARENTID], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID], [CODE]) VALUES ('a7fd55cb0bfd4a28a560a29c65b00102', '测试1_2', '1', 'a7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'e4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'tenant', '00010002');
INSERT INTO [IUAPD_TREELIST] ([ID], [NAME], [IS_SON], [PARENTID], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID], [CODE]) VALUES ('a7fd55cb0bfd4a28a560a29c65b00103', '测试1_3', '1', 'a7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'e4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'tenant', '00010003');
INSERT INTO [IUAPD_TREELIST] ([ID], [NAME], [IS_SON], [PARENTID], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID], [CODE]) VALUES ('a7fd55cb0bfd4a28a560a29c65b00104', '测试1_4', '1', 'a7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'e4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'tenant', '00010004');
INSERT INTO [IUAPD_TREELIST] ([ID], [NAME], [IS_SON], [PARENTID], [CREATE_TIME], [CREATE_USER], [LAST_MODIFIED], [LAST_MODIFY_USER], [TS], [DR], [BPM_STATE], [TENANT_ID], [CODE]) VALUES ('a7fd55cb0bfd4a28a560a29c65b00105', '测试1_5', '1', 'a7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'e4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'tenant', '00010005');
GO

INSERT INTO WB_APP_APPS VALUES ('27228e888fcfec75f8fe57b7', '参照示例', '2', '6c173e474f3742a1b70960f4e1cca4df', '646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/ref-demo#/', null, null, 'pap pap-bujuguanli', null, 'refdemo', null, 'tenant', 'url', '2', 'wbalone', null, 'apparea', null, 'U001', null, null, 'RefDemo', '参照示例', null, null, null);
INSERT INTO WB_LABEL_RELATION VALUES ('27228e888fcfec75f8fe57b7', 'syssource', 'refdemo', null, 'tenant', 'wbalone', null, '27228e888fcfec75f8fe57b7', 'app');
INSERT INTO WB_LABEL_RELATION VALUES ('27228e888fcfec75f8fe57b8', 'mgrsource', 'refdemo', null, 'tenant', 'wbalone', null, '27228e888fcfec75f8fe57b7', 'app');
INSERT INTO IEOP_ROLE_PERMISSION  ("ID", "ROLE_ID", "ROLE_CODE", "PERMISSION_ID", "PERMISSION_CODE", "PERMISSION_TYPE", "TENANT_ID", "SYS_ID") VALUES ('27228e888fcfec75f8fe57b7', 'R001', 'admin', '27228e888fcfec75f8fe57b7', 'refdemo', '1', 'tenant', 'wbalone');
INSERT INTO WB_APP_MENU (ID, FUNC_ID, ICON, ISENABLE, ISVISIBLE, IS_VIRTUAL_NODE, PARENT_ID, CLASSIFY, LAYOUT_ID, SORT, CREATE_TIME, NAME, TENANT_ID, VERSION, LABEL, TS, DR, OPENVIEW, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('a917a3c1bf80422ab2f17ebe61357cde', 'refdemo', ' iconfont icon-appicon ', 'Y', 'Y', 'N', 'e238812395b647969d77be13757abb1e', NULL, 'refdemo', '7', null, '参照示例', 'tenant', '0', 'common', NULL, NULL, 'curnpage', 'refdemo', '参照示例', '', '', '');


-- 编码规则预置数据
INSERT INTO PAP_BCR_RULEBASE(PK_BILLCODEBASE, PKBILLOBJ, RULECODE, RULENAME, CODEMODE, ISEDITABLE, ISAUTOFILL, FORMAT, ISDEFAULT, ISUSED, ISLENVAR, ISGETPK, RENTERID, SYSID, CREATEDATE, RULENAME2, RULENAME3, RULENAME4, RULENAME5, RULENAME6) VALUES ('d5d07774b0ee47689cc6e0788fbae483', 'e8a7b4bc-1e8c-4426-8261-226098b427c1', 'A', 'A', 'behCode', 'N', 'Y', NULL, 'Y', NULL, 'Y', NULL, 'tenant', 'wbalone', null, NULL, NULL, NULL, NULL, NULL);

INSERT INTO PAP_BCR_RULEBASE(PK_BILLCODEBASE, PKBILLOBJ, RULECODE, RULENAME, CODEMODE, ISEDITABLE, ISAUTOFILL, FORMAT, ISDEFAULT, ISUSED, ISLENVAR, ISGETPK, RENTERID, SYSID, CREATEDATE, RULENAME2, RULENAME3, RULENAME4, RULENAME5, RULENAME6) VALUES ('76987c6767d943d7a3cd7ca9fe6a99c9', '9c5154ec-25ce-42d7-88cf-47197afa1bf7', 'B2', 'B2', 'behCode', 'N', 'N', NULL, 'Y', NULL, 'Y', NULL, 'tenant', 'wbalone', null, NULL, NULL, NULL, NULL, NULL);

INSERT INTO PAP_BCR_RULEBASE(PK_BILLCODEBASE, PKBILLOBJ, RULECODE, RULENAME, CODEMODE, ISEDITABLE, ISAUTOFILL, FORMAT, ISDEFAULT, ISUSED, ISLENVAR, ISGETPK, RENTERID, SYSID, CREATEDATE, RULENAME2, RULENAME3, RULENAME4, RULENAME5, RULENAME6) VALUES ('8e9d9cf013cc4c368a83517dd4a1ac80', 'bd25d00c-cacd-4244-b847-42b2a5fbff65', 'B3', 'B3', 'behCode', 'N', 'N', NULL, 'Y', NULL, 'Y', NULL, 'tenant', 'wbalone', null, NULL, NULL, NULL, NULL, NULL);


INSERT INTO PAP_BCR_ELEM(PK_BILLCODEELEM, PK_BILLCODEBASE, ELEMTYPE, ELEMVALUE, ELEMLENTH, ISREFER, EORDER, FILLSTYLE, DATEDISPLAYFORMAT, FILLSIGN, CREATEDATE) VALUES ('4082e88e2d404ce984536d58bb517843', '76987c6767d943d7a3cd7ca9fe6a99c9', '1', 'B2', '2', '0', '0', '-1', NULL, NULL, '2019-05-21');
INSERT INTO PAP_BCR_ELEM(PK_BILLCODEELEM, PK_BILLCODEBASE, ELEMTYPE, ELEMVALUE, ELEMLENTH, ISREFER, EORDER, FILLSTYLE, DATEDISPLAYFORMAT, FILLSIGN, CREATEDATE) VALUES ('d0233efc35114d809f37d7c29a60c5a2', '76987c6767d943d7a3cd7ca9fe6a99c9', '2', NULL, '8', '3', '1', '-1', 'yyyyMMdd', NULL, '2019-05-21');
INSERT INTO PAP_BCR_ELEM(PK_BILLCODEELEM, PK_BILLCODEBASE, ELEMTYPE, ELEMVALUE, ELEMLENTH, ISREFER, EORDER, FILLSTYLE, DATEDISPLAYFORMAT, FILLSIGN, CREATEDATE) VALUES ('2b160295a3214f2b89b0e0b1b45a0d2b', '76987c6767d943d7a3cd7ca9fe6a99c9', '0', '0', '3', '0', '2', '-1', NULL, NULL, '2019-05-21' );
INSERT INTO PAP_BCR_ELEM(PK_BILLCODEELEM, PK_BILLCODEBASE, ELEMTYPE, ELEMVALUE, ELEMLENTH, ISREFER, EORDER, FILLSTYLE, DATEDISPLAYFORMAT, FILLSIGN, CREATEDATE) VALUES ('7fe6dd1200ca4733b6a2261b21d3df12', '8e9d9cf013cc4c368a83517dd4a1ac80', '1', 'B3', '2', '0', '0', '-1', NULL, NULL, '2019-05-21');
INSERT INTO PAP_BCR_ELEM(PK_BILLCODEELEM, PK_BILLCODEBASE, ELEMTYPE, ELEMVALUE, ELEMLENTH, ISREFER, EORDER, FILLSTYLE, DATEDISPLAYFORMAT, FILLSIGN, CREATEDATE) VALUES ('a1bb77031d0f436d8b60cb515c3584a5', '8e9d9cf013cc4c368a83517dd4a1ac80', '2', NULL, '8', '3', '1', '-1', 'yyyyMMdd', NULL, '2019-05-21');
INSERT INTO PAP_BCR_ELEM(PK_BILLCODEELEM, PK_BILLCODEBASE, ELEMTYPE, ELEMVALUE, ELEMLENTH, ISREFER, EORDER, FILLSTYLE, DATEDISPLAYFORMAT, FILLSIGN, CREATEDATE) VALUES ('4e5639dd3aff402b8ab321fdde19c870', '8e9d9cf013cc4c368a83517dd4a1ac80', '0', '0', '3', '0', '2', '-1', NULL, NULL, '2019-05-21' );
INSERT INTO PAP_BCR_ELEM(PK_BILLCODEELEM, PK_BILLCODEBASE, ELEMTYPE, ELEMVALUE, ELEMLENTH, ISREFER, EORDER, FILLSTYLE, DATEDISPLAYFORMAT, FILLSIGN, CREATEDATE) VALUES ('98530cff80f646b89de4a4957ff01e0b', 'd5d07774b0ee47689cc6e0788fbae483', '1', 'A', '1', '0', '0', '-1', NULL, NULL, '2019-05-21');
INSERT INTO PAP_BCR_ELEM(PK_BILLCODEELEM, PK_BILLCODEBASE, ELEMTYPE, ELEMVALUE, ELEMLENTH, ISREFER, EORDER, FILLSTYLE, DATEDISPLAYFORMAT, FILLSIGN, CREATEDATE) VALUES ('c7ca0252f9fe41f492fcd88b16fb721c', 'd5d07774b0ee47689cc6e0788fbae483', '2', NULL, '8', '3', '1', '-1', 'yyyyMMdd', NULL, '2019-05-21');
INSERT INTO PAP_BCR_ELEM(PK_BILLCODEELEM, PK_BILLCODEBASE, ELEMTYPE, ELEMVALUE, ELEMLENTH, ISREFER, EORDER, FILLSTYLE, DATEDISPLAYFORMAT, FILLSIGN, CREATEDATE) VALUES ('c84019f6de5f4247becf48a551c07ad3', 'd5d07774b0ee47689cc6e0788fbae483', '0', '0', '3', '0', '2', '-1', NULL, NULL, '2019-05-21');

-- 统一业务对象支持部
INSERT INTO BIZ_OBJECT (ID,CODE,NAME,PARENTID,ISCATALOG,ASSIGNTYPE,SYSID,TENANTID,NAME2,NAME3,NAME4,NAME5,NAME6,MAPPING_ENTITY,CREATE_PERSON,MODIFY_PERSON,CREATE_DATE,MODIFY_DATE,DR,STATUS)VALUES('4b06e527-441e-4734-946b-ac48cab8677d','Demo','典型案例','00001','Y',NULL,'wbalone','tenant','typical cases','典型案例',NULL,NULL,NULL,NULL,NULL,'U001',null,null,'0','0');

INSERT INTO BIZ_OBJECT (ID,CODE,NAME,PARENTID,ISCATALOG,ASSIGNTYPE,SYSID,TENANTID,NAME2,NAME3,NAME4,NAME5,NAME6,MAPPING_ENTITY,CREATE_PERSON,MODIFY_PERSON,CREATE_DATE,MODIFY_DATE,DR,STATUS)VALUES
	('e8a7b4bc-1e8c-4426-8261-226098b427c1','iuapd_asval','A','4b06e527-441e-4734-946b-ac48cab8677d','N',NULL,'wbalone','tenant','A','A',NULL,NULL,NULL,NULL,NULL,'U001',null,null,'0','0');

INSERT INTO BIZ_OBJECT (ID,CODE,NAME,PARENTID,ISCATALOG,ASSIGNTYPE,SYSID,TENANTID,NAME2,NAME3,NAME4,NAME5,NAME6,MAPPING_ENTITY,CREATE_PERSON,MODIFY_PERSON,CREATE_DATE,MODIFY_DATE,DR,STATUS)VALUES
	('9c5154ec-25ce-42d7-88cf-47197afa1bf7','masterdetail-one','B2','4b06e527-441e-4734-946b-ac48cab8677d','N',NULL,'wbalone','tenant','B2','B2',NULL,NULL,NULL,NULL,NULL,NULL,null,NULL,'0','0');

 INSERT INTO BIZ_OBJECT (ID,CODE,NAME,PARENTID,ISCATALOG,ASSIGNTYPE,SYSID,TENANTID,NAME2,NAME3,NAME4,NAME5,NAME6,MAPPING_ENTITY,CREATE_PERSON,MODIFY_PERSON,CREATE_DATE,MODIFY_DATE,DR,STATUS)VALUES
 ('bd25d00c-cacd-4244-b847-42b2a5fbff65','passenger','B3','4b06e527-441e-4734-946b-ac48cab8677d','N',NULL,'wbalone','tenant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,null,NULL,'0','0');

	-- 对应页面使用场景，标签关系表
	INSERT INTO wb_label_relation(id, labelcode, sourcecode, create_date, tenant_id, system, lableid, sourceid, type) VALUES ('4d3799d2c42748fa8c28ac7b873abebb', 'bizObject', NULL, NULL, 'tenant', 'wbalone', NULL, 'e8a7b4bc-1e8c-4426-8261-226098b427c1', 'billcode');

	INSERT INTO  wb_label_relation(id, labelcode, sourcecode, create_date, tenant_id, system, lableid, sourceid, type) VALUES ('1e1ffb8cab0240748a9bbbac8837ec4e', 'bizObject', NULL, NULL, 'tenant', 'wbalone', NULL, 'bd25d00c-cacd-4244-b847-42b2a5fbff65', 'billcode');

	INSERT INTO wb_label_relation(id, labelcode, sourcecode, create_date, tenant_id, system, lableid, sourceid, type) VALUES ('2c8be70cd48e4066be3c4e38eec0f9a7', 'bizObject', NULL, NULL, 'tenant', 'wbalone', NULL, '9c5154ec-25ce-42d7-88cf-47197afa1bf7', 'message');

INSERT INTO wb_label_relation(id, labelcode, sourcecode, create_date, tenant_id, system, lableid, sourceid, type) VALUES ('3b6644b82f4c4132ba7051cf01d16450', 'bizObject', NULL, NULL, 'tenant', 'wbalone', NULL, '9c5154ec-25ce-42d7-88cf-47197afa1bf7', 'billcode');

INSERT INTO wb_label_relation(id, labelcode, sourcecode, create_date, tenant_id, system, lableid, sourceid, type) VALUES ('6bb54c2b59d44f3e8dddd31af00315c9', 'bizObject', NULL, NULL, 'tenant', 'wbalone', NULL, '9c5154ec-25ce-42d7-88cf-47197afa1bf7', 'bpm');
GO